package cn.szzsi.service;

import cn.szzsi.common.model.Member;
import cn.szzsi.common.model.UserFeedback;

import java.util.List;

/**
 * Created by admin on 2017/1/18.
 */
public class UserFeedBackService {

    public static final UserFeedBackService me = new UserFeedBackService();

    public List<UserFeedback> getAllUserFeedBack(Member member) {
        String sql = "select f.content,f.uid,f.createDate,fr.replier,fr.content as fcontent from mall_user_feedback f left join mall_user_feedback_reply fr on f.id = fr.fid where f.mid = ? order by createDate desc";
        List<UserFeedback> list = UserFeedback.dao.find(sql,member.getStr("id"));
        return list;
    }

}
